CREATE TABLE [SSB].[LotLevelHoldings]
(
[State Street Identifier] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Calendar Date] [date] NULL,
[Security Description] [nvarchar] (75) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CUSIP] [nvarchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Lot Number] [decimal] (38, 10) NULL,
[Trade Date] [date] NULL,
[Actual Settlement Date] [date] NULL,
[Asset Class] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Base Market Value] [decimal] (38, 10) NULL,
[Base Original Cost] [decimal] (38, 10) NULL,
[Shares/Par Value] [decimal] (38, 10) NULL,
[Base Unrealized Gain/Loss] [decimal] (38, 10) NULL,
[Amortized Cost - Base] [decimal] (38, 10) NULL,
[Amortized Cost - Local] [decimal] (38, 10) NULL,
[Client Fund] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Account Number] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Variable Rate] [decimal] (38, 10) NULL,
[Trade ID] [nvarchar] (11) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Moody's Quality Rating] [nvarchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Maturity Date] [datetime] NULL,
[Interest Rate] [decimal] (38, 10) NULL,
[Alternate Lot Number] [nvarchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Issued at OID] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Dummy Cusip Indicator] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ISIN Number] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Report Date] [datetime] NULL,
[Post Date] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Cash Date] [datetime] NULL,
[Accrued Amount - Base] [decimal] (38, 10) NULL,
[Accrual Type Code] [nvarchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Lot Status] [nvarchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Purchase Yield] [decimal] (38, 10) NULL,
[Ticker] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Variable Rate Frequency] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Current Income Date] [datetime] NULL,
[Accrual Basis Description] [nvarchar] (13) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Accrual Date] [datetime] NULL,
[Adjustment Indicator] [nvarchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Closing Price] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Current Call Price] [decimal] (38, 10) NULL,
[IM ID] [nvarchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IM Account ID] [nvarchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Local Total Accrual Today] [decimal] (38, 10) NULL,
[Variable Rate Reset Date] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Base Original Unit Cost] [decimal] (38, 10) NULL,
[Base Unit Cost] [decimal] (38, 10) NULL,
[Daily Amortization Factor Base] [decimal] (38, 10) NULL,
[Amortization Days Count] [decimal] (38, 10) NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [NonClusteredIndex-20140314-033649] ON [SSB].[LotLevelHoldings] ([State Street Identifier], [Calendar Date]) INCLUDE ([Account Number], [Accrual Basis Description], [Accrual Date], [Accrual Type Code], [Accrued Amount - Base], [Actual Settlement Date], [Adjustment Indicator], [Alternate Lot Number], [Amortization Days Count], [Amortized Cost - Base], [Amortized Cost - Local], [Asset Class], [Base Market Value], [Base Original Cost], [Base Original Unit Cost], [Base Unit Cost], [Base Unrealized Gain/Loss], [Cash Date], [Client Fund], [Closing Price], [Current Call Price], [Current Income Date], [CUSIP], [Daily Amortization Factor Base], [Dummy Cusip Indicator], [IM Account ID], [IM ID], [Interest Rate], [ISIN Number], [Issued at OID], [Local Total Accrual Today], [Lot Number], [Lot Status], [Maturity Date], [Moody's Quality Rating], [Post Date], [Purchase Yield], [Report Date], [Security Description], [Shares/Par Value], [Ticker], [Trade Date], [Trade ID], [Variable Rate], [Variable Rate Frequency], [Variable Rate Reset Date]) ON [PRIMARY]
GO
